MySQL powers some of Facebook’s most important workloads. We actively develop new features in MySQL to support our evolving requirements which change many different areas of MySQL, including client connectors, storage engine, optimizer, and replication. Each new major version of MySQL requires significant time and effort to migrate our workloads. The challenges include: porting our custom features, minimizing changes needed for application queries, and fixing performance regressions.

In this talk, we will share our story about how we went about achieving the migration from 5.6 → 8.0 for our workloads at Meta.